From 2dfb061782b79abe4122c6f888ea05ce4316db67 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 15:20:43 +0000 Subject: [PATCH] Execute SWELLING_SOURCES v.s. EntryDate check only when necessary --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index bf1f0bf..5a83cc0 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -548,7 +548,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () -- Cannot have a SWELLING_SOURCES row before -- the individual was studied. - IF NEW.entrydate <> OLD.entrydate THEN + IF NEW.entrydate > OLD.entrydate THEN SELECT swelling_sources.id, swelling_sources.date , swelling_sources.swellingmin, swelling_sources.swellingmax INTO a_id , a_date -- 2.34.1